a Program to Create a Table

import java.sql.*;
public class Table
{
public static void main(String args[])
{
Connection con=null;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:vision","scott","tiger");
Statement st=con.createStatement();
st.executeUpdate("create table abc(eno number(5),na varchar2(20),
sal number(5))");
System.out.println("Table Created");
}
catch(ClassNotFoundException e)
{
e.printStackTrace();
}
catch(SQLException e)
{
e.printStackTrace();
}
finally
{
try
{
if(con!=null)
con.close();
}
catch(SQLException e)
{
e.printStackTrace();
}
}
}
}

Program to Insert the Data into a Table
import java.sql.*;
public class Insert
{
        public static void main(String args[])
        {
                Connection con=null;
                try
                {
                        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                        con=DriverManager.getConnection("jdbc:odbc:vision","scott","tiger");
                        Statement st=con.createStatement();
                        st.executeUpdate(“insert into abc values(100,’prasad’,5600)”);                      
                        System.out.println("Row Inserted");
                }
                catch(ClassNotFoundException e)
                {
                        e.printStackTrace();
                }
                catch(SQLException e)
                {
                        e.printStackTrace();
                }
                finally
                {
                        try
                        {
                                if(con!=null)
                                        con.close();
                        }
                        catch(SQLException e)
                        {
                                e.printStackTrace();
                        }
                }
        }
}

 

Write a Program to Update the Table

import java.sql.*;
public class Update
{
public static void main(String args[])
{
Connection con=null;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:vision","scott","tiger");
Statement st=con.createStatement();
St.executeUpdate(“update abc set sal=sal+1000”);                      
System.out.println("Table Updated");
}
catch(ClassNotFoundException e)
{
e.printStackTrace();
}
catch(SQLException e)
{
e.printStackTrace();
}
finally
{
try
{
if(con!=null)
con.close();
}
catch(SQLException e)
{
e.printStackTrace();
}
}
}
}

Write a program to delete the record from the table.

import java.sql.*;
public class Delete
{
public static void main(String args[])
{
Connection con=null;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:vision","scott","tiger");
Statement st=con.createStatement();
st.executeUpdate(“delete from abc where eno=100”);                       
System.out.println("Row deleted");
}
catch(ClassNotFoundException e)
{
e.printStackTrace();
}
catch(SQLException e)
{
e.printStackTrace();
}
finally
{
try
{
if(con!=null)
con.close();
}
catch(SQLException e)
{
e.printStackTrace();
}
}
}
}

Program to Insert the Data into a Table
import java.sql.*;
public class Insert
{
        public static void main(String args[])
        {
                Connection con=null;
                try
                {
                        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                        con=DriverManager.getConnection("jdbc:odbc:vision","scott","tiger");
                        Statement st=con.createStatement();
                        st.executeUpdate(“insert into abc values(100,’prasad’,5600)”);                      
                        System.out.println("Row Inserted");
                }
                catch(ClassNotFoundException e)
                {
                        e.printStackTrace();
                }
                catch(SQLException e)
                {
                        e.printStackTrace();
                }
                finally
                {
                        try
                        {
                                if(con!=null)
                                        con.close();
                        }
                        catch(SQLException e)
                        {
                                e.printStackTrace();
                        }
                }
        }
}

 

Write a Program to Update the Table

import java.sql.*;
public class Update
{
public static void main(String args[])
{
Connection con=null;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:vision","scott","tiger");
Statement st=con.createStatement();
St.executeUpdate(“update abc set sal=sal+1000”);                      
System.out.println("Table Updated");
}
catch(ClassNotFoundException e)
{
e.printStackTrace();
}
catch(SQLException e)
{
e.printStackTrace();
}
finally
{
try
{
if(con!=null)
con.close();
}
catch(SQLException e)
{
e.printStackTrace();
}
}
}
}

Write a program to delete the record from the table.

import java.sql.*;
public class Delete
{
public static void main(String args[])
{
Connection con=null;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:vision","scott","tiger");
Statement st=con.createStatement();
st.executeUpdate(“delete from abc where eno=100”);                       
System.out.println("Row deleted");
}
catch(ClassNotFoundException e)
{
e.printStackTrace();
}
catch(SQLException e)
{
e.printStackTrace();
}
finally
{
try
{
if(con!=null)
con.close();
}
catch(SQLException e)
{
e.printStackTrace();
}
}
}
}